Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 36

NOT, AND, OR and XOR are

a) Logical Operators

b) Arithmetic operators

c) Relational operators

d) All of the above

e) None of these

Question : 37

Getting data from a cell located in a different sheet is called.

a) Accessing

b) Referencing

c) Updating

d) Functioning

e) None of these

Question : 38

Except for the ...... function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result

a) IF

b) AND

c) OR

d) NOT

e) None of these

Question : 39

You can use the horizontal and vertical scroll bars to

a) Split a, worksheet into two panes

b) View different rows and columns edit the contents of a cell

c) Edit the contents of a cell

d) view different worksheets

e) None of these

Question : 40

In Excel which of the following is not a way to complete a cell entry?

a) Pressing enter

b) Pressing any arrow key on the keyboard

c) Clicking the Enter button on the Formula bar

d) Pressing spacebar